Test Series - computer fundamental

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

Test Number 70/95

Q: DBMS is a set of __________ to access the data.
A. Codes
B. Programs
C. Information
D. Metadata 
Solution: Database is a set of programs designed to access the data. It contains information about a particular enterprise.
Q: DBMS provides a convenient and efficient environment.
A. True
B. False
C. none
D. ..
Solution: The statement is true. DBMS stands for Database Management System. It provides an efficient and easy to use environment.
Q: Which of the following isn’t a level of abstraction?
A. physical
B. logical
C. user
D. view
Solution: There are three levels of abstraction: physical, logical and the view level. These three levels are involved in DBMS.
Q: A level that describes how a record is stored.
A. physical
B. logical
C. user
D. view
Solution: The answer is physical. The physical level describes how the record gets stored.
e.g. Customer.
Q: The ______level helps application programs hide the details of data types.
A. physical
B. logical
C. user
D. view 
Solution: The application programs hide details of datatypes. Views can also hide information for security purposes.
Q: A logical structure of the database.
A. Schema
B. Attribute
C. Parameter
D. Instance
Solution: A schema is the logical structure of the database. e.g A set of customers and accounts and their relationship.
Q: The actual content in the database at a particular point.
A. Schema
B. Attribute
C. Parameter
D. Instance
Solution: The answer is Instance. Instance is the actual content of the database at a particular point of time.
Q: Which of the following is not an object-based logical model?
A. ER
B. Network
C. Semantic
D. Functional
Solution: Network model is a part of record-based logical model and not object-based. Others are object based models. ER stands for Entity-relationship.
Q: SQL is _______
A. Relational
B. Network
C. IMS
D. Hierarchical
Solution: SQL or structured query language is a relational model. It comes under record-based logical models.
Q: A level that describes data stored in a database and the relationships among the data.
A. physical
B. logical
C. user
D. view
Solution: The answer is logical. The logical level describes the relationships between the data. Physical level describes how the data is stored.

You Have Score    /10